2013-05-14 - 5910.200 - Rel Notes - Contracts - Release 036 #BIReleases2013
Release Notes:
5910.200 - Contracts - SA130
Admin Info
Purpose
|
Removing Repository functions for Subreport OSA100
|
Release No
|
036
|
Submitted
|
05-14-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Production in BI 4.0 DEV to Respective Reports folder in BI 4.0 DEV
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Narendra Koraganji
|
Object(s) Tested By
|
Narendra Koraganji
|
Report Name
SA130 - Miami Scorecard
BEx Query
ZMP_OOCON_Q004
ZMP_OOCON_Q003
ZMP_OOCON_Q005
ZMP_OPASA_Q014
ZZCOPA_C03_043
ZSDC_SSL_005
NEC Crystal Reports Standards Check
1. SA130 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA130 NEC CR checklist has been sent to NEC and also attached here for reference:
Open Orders by Season - OSA130 Sub Report Validation
Test Conducted
Grouping: Sales Org:5th & Ocean > CUSTOM
SNo
|
Test Case
|
Value in CR
|
Value in BI 4.0 Production
|
Pass/Fail
|
1
|
No. of Orders
|
1,434
|
1,434
|
Pass
|
2
|
Confirmed Qty
|
1,048,182
|
1,048,182
|
Pass
|
3
|
Sales Org Currency
|
10,318,649
|
10,318,649
|
Pass
|
4
|
Corporate Currency
|
10,318,649
|
10,318,649
|
Pass
|
Open Orders by Fiscal Year - OSA100 Sub Report Validation
Test Conducted
Grouping: Sales Org:5th & Ocean > 5th & Ocean Sales > 2013 > October 2013
SNo
|
Test Case
|
Value in CR
|
Value in BI 4.0 Production
|
Pass/Fail
|
1
|
No. of Orders
|
7
|
7
|
Pass
|
2
|
Confirmed Qty
|
1,176
|
1,176
|
Pass
|
3
|
Sales Org Currency
|
26,972
|
26,972
|
Pass
|
4
|
Corporate Currency
|
26,972
|
26,972
|
Pass
|
Open Orders at Risk of Cancel - OSA172 Sub Report Validation
Test Conducted
Grouping: Sales Org:5th & Ocean > 5th & Ocean Sales
SNo
|
Test Case
|
Value in CR
|
Value in BI 4.0 Production
|
Pass/Fail
|
1
|
No. of Orders
|
786
|
786
|
Pass
|
2
|
Confirmed Qty
|
100,591
|
100,591
|
Pass
|
3
|
Sales Org Currency
|
907,978
|
907,978
|
Pass
|
4
|
Corporate Currency
|
907,978
|
907,978
|
Pass
|
Sales Analysis by Sales Org - SA900 Sub Report Validation
Test Conducted
Grouping: Sales Org:5th & Ocean > 5th & Ocean Sales > VICTORIAS SECRET >2013
SNo
|
Test Case
|
Value in CR for 2013
|
Value in CR for 2012
|
Value in Production of 2013
|
Value in Production for 2012
|
Pass/Fail
|
1
|
Quantity
|
1,352,299
|
2,690,228
|
1,352,299
|
2,690,228
|
Pass
|
2
|
Sales Org Currency
|
12,176,664
|
31,915,738
|
12,176,664
|
31,915,738
|
Pass
|
3
|
Corporate Currency
|
12,176,664
|
31,915,738
|
12,176,664
|
31,915,738
|
Pass
|
Shipped and Open by Region - SA170 Sub Report Validation
Test Conducted
Grouping: Sales Org:5th & Ocean > North America > May
SNo
|
Test Case
|
Value in CR
|
Value in BI 4.0 Production
|
Pass/Fail
|
1
|
Shipped
|
3,694,472
|
3,694,472
|
Pass
|
2
|
Open
|
1,271,716
|
1,271,716
|
Pass
|
3
|
Total
|
4,966,188
|
4,966,188
|
Pass
|
4
|
Last Year
|
2,961,291
|
2,961,291
|
Pass
|
5
|
Variance
|
2,004,897
|
2,004,897
|
Pass
|
6
|
Coverage %
|
168
|
168
|
Pass
|
Service Level - SL100 Sub Report Validation
Test Conducted
Grouping: Sales Org:5th & Ocean > 2013 > Jul
SNo
|
Test Case
|
Value in CR
|
Value in BI 4.0 Production
|
Pass/Fail
|
1
|
Ordered
|
168
|
168
|
Pass
|
2
|
Delivered
|
24
|
24
|
Pass
|
3
|
Ontime
|
24
|
24
|
Pass
|
4
|
Late
|
0
|
0
|
Pass
|
5
|
Ontime %
|
100%
|
100%
|
Pass
|
6
|
Fill Rate %
|
14.29%
|
14.29%
|
Pass
|
7
|
Confirmed
|
24
|
24
|
Pass
|
8
|
Delivered
|
24
|
24
|
Pass
|
9
|
Ontime
|
0
|
0
|
Pass
|
10
|
Late
|
0
|
0
|
Pass
|
11
|
Ontime %
|
100%
|
100%
|
Pass
|
12
|
Fill Rate %
|
100%
|
100%
|
Pass
|
13
|
First Pass
|
24
|
24
|
Pass
|
14
|
First Pass %
|
100%
|
100%
|
Pass
|
MRP Exceptions - OPP200 Sub Report Validation
Test Conducted
Plant: Blue Label > Upstairs BCA
SNo
|
Test Case
|
Value in CR
|
Value in BI 4.0 Production
|
Pass/Fail
|
1
|
No BOM exists for material & &
|
0
|
0
|
Pass
|
2
|
No routing data existing.
|
0
|
0
|
Pass
|
3
|
Plan process according to schedule
|
204
|
204
|
Pass
|
4
|
PlOr &: Changed to foreward scheduling.
|
34
|
34
|
Pass
|
5
|
Postpone process & & &
|
1,058
|
1,058
|
Pass
|
6
|
PuRq &: Changed to foreward scheduling.
|
170
|
170
|
Pass
|
7
|
PuRq &: Delivery date is in the past.
|
0
|
0
|
Pass
|
8
|
PuRq &: Release date is in the past.
|
0
|
0
|
Pass
|
9
|
Scheduling: Master data inconsistent
|
0
|
0
|
Pass
|
10
|
Size information for BOM & & is incomplete.
|
2
|
2
|
Pass
|
11
|
Start date in the past & & &
|
0
|
0
|
Pass
|
12
|
Stock fallen below safety stock level
|
0
|
0
|
Pass
|
13
|
Total
|
4,535
|
4,535
|
Pass
|
Reference Document(Specification)
2013-03-15 - 5910.200 - Enhancement - Contract Reports